home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Cream of the Crop 20
/
Cream of the Crop 20 (Terry Blount) (1996).iso
/
business
/
exlwk4up.zip
/
_MSSETUP.EX_
/
DISK1
/
XLCONVW4.MS_
/
XLCONVW4.bin
Wrap
Text File
|
1994-11-07
|
4KB
|
170 lines
'
' File: XLCONVW4.MST
' Description: Excel WK4 File Converter
' Platform: Microsoft Windows
'
'$INCLUDE 'setupapi.inc'
'$INCLUDE 'msdetect.inc'
CONST SEARCHDONE = 100
CONST INILOOP = 200
CONST SEARCHING = 1000
CONST EXITSUCCESS = 2000
CONST EXITFAILURE = 3000
CONST EXITNOEXCEL = 4000
GLOBAL DRIVES$
DECLARE FUNCTION MakePath (szDir$, szFile$) AS STRING
DECLARE FUNCTION MakeDirectory (szDir$) AS STRING
DECLARE FUNCTION StripFileName (szPath$) AS STRING
DECLARE FUNCTION StrStripped (value%) AS STRING
INIT:
DRIVES$ = "drives"
CUIDLL$ = "mscuistf.dll"
HELPPROC$ = "FHelpDlgProc"
PRODUCTFILE$ = "XLCONVW4"
PROGRAMFILE$ = "EXCEL.EXE"
EXCEL5INIFILE$ = "EXCEL5.INI"
windir$ = GetWindowsDir
ON ERROR GOTO ERRQUIT
szInf$ = GetSymbolValue("STF_SRCINFPATH")
IF szInf$ = "" THEN
szInf$ = GetSymbolValue("STF_CWDDIR") + PRODUCTFILE$ + ".INF"
ENDIF
ReadInfFile szInf$
'
' find the excel directory
'
sz$ = UIStartDlg(CUIDLL$, SEARCHING, "FModelessDlgProc", 0, "")
cursor% = ShowWaitCursor()
GetValidDrivesList DRIVES$
FOR i% = 1 TO GetListLength(DRIVES$) STEP 1
find$ = FindFileInTree(PROGRAMFILE$, GetListItem(DRIVES$, i%) + ":\")
IF find$ <> "" THEN
GOTO SEARCHDONE
ENDIF
NEXT i%
find$ = ""
SEARCHDONE:
RestoreCursor cursor%
UIPop 1
IF find$ = "" THEN
sz$ = UIStartDlg(CUIDLL$, EXITNOEXCEL, "FInfo0DlgProc", 0, "")
GOTO ERRQUIT
ENDIF
'
' install files
'
ClearCopyList
source$ = GetSymbolValue("STF_SRCDIR")
dest$ = StripFileName(find$)
AddSectionFilesToCopyList "Excel", source$, dest$
CopyFilesInCopyList
'
' update the excel .ini file
'
inifile$ = MakePath(windir$, EXCEL5INIFILE$)
section$ = "Converters"
keystring1$ = "Lotus 1-2-3 Release 4 or 5 (*.wk4)"
keystring3$ = "*.wk4"
keyupdate$ = keystring1$ + "," + MakePath(dest$, PRODUCTFILE$ + ".DLL") + "," + keystring3
i% = 1
INILOOP:
key$ = "conv" + StrStripped(i%)
keystring$ = GetIniKeyString(inifile$, section$, key$)
IF keystring$ = "" THEN
CreateIniKeyValue inifile$, section$, key$, keyupdate$, cmoOverwrite
ELSEIF UCASE$(MID$(keystring$, 1 + LEN(keystring$) - LEN(keystring3$), LEN(keystring3$))) = UCASE$(keystring3$) THEN
CreateIniKeyValue inifile$, section$, key$, keyupdate$, cmoOverwrite
ELSE
i% = i% + 1
GOTO INILOOP
ENDIF
'
' update the registration database and windows .ini file
'
QUIT:
sz$ = UIStartDlg(CUIDLL$, EXITSUCCESS, "FInfo0DlgProc", 0, "")
END
ERRQUIT:
UIPopAll
sz$ = UIStartDlg(CUIDLL$, EXITFAILURE, "FInfo0DlgProc", 0, "")
END
FUNCTION MakePath (szDir$, szFile$) STATIC AS STRING
IF szDir$ = "" THEN
MakePath = szFile$
ELSEIF szFile$ = "" THEN
MakePath = szDir$
ELSEIF MID$(szDir$, LEN(szDir$), 1) = "\" THEN
MakePath = szDir$ + szFile$
ELSE
MakePath = szDir$ + "\" + szFile$
ENDIF
END FUNCTION
FUNCTION StripFileName (szPath$) STATIC AS STRING
j% = 0
FOR i% = LEN(szPath$) TO 1 STEP -1
IF MID$(szPath$, i%, 1) = "\" THEN
j% = i% - 1
i% = 1
ENDIF
NEXT i%
IF j% = 0 THEN
StripFileName = szPath$
ELSE
StripFileName = MID$(szPath$, 1, j%)
ENDIF
END FUNCTION
FUNCTION StrStripped (value%) STATIC AS STRING
s$ = STR$(value%)
StrStripped = MID$(s$, 2, LEN(s$) - 1)
END FUNCTION